<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hzb.erp.api.pc.sys.mapper.RegionMapper">
    <sql id="Base_Column_List">
        id,pid,short_name,
        name,merger_name,level,
        pinyin,code,zip_code,
        first,lng,lat
    </sql>
    <select id="getByPid" resultType="com.hzb.erp.api.pc.sys.entity.Region">
        select id,pid,short_name,name,merger_name
        from region where pid = #{pid}
    </select>
</mapper>
